package org.goldenport.g3.sample

import org.goldenport.g3._
import org.goldenport.g3.messages.sql._

/**
 * @since   Apr. 11, 2010
 * @version Aug. 31, 2010
 * @author  ASAMI, Tomoharu
 **/
class SqlChannel extends G3Application {
  sqlspace('mydb, "jdbc:derby:;shutdown=true", "user1", "user1", "org.apache.derby.jdbc.EmbeddedDriver")

/*
  agent('create) { x =>
    Create("book") 
  }

  agent('select) { x =>
    Select("Update table")
  }

  agent('insert) { x =>
    Insert("Update table")
  }

  agent('update) { x =>
    Update("Update table")
  }

  agent('delete) { x =>
    Delete("Update table")
  }

  agent('drop) { x =>
    Drop("Update table")
  }

  agent('sql) { x =>
    Sqlspace("Update table XXX")
  }
*/

  start(Create("book", DDL(Column('number, INTEGER)))) publish("mydb")
}
